SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025093 LIMIT 1 [ RunTime:0.002001s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025093 [ RunTime:0.006601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378677,439649,791041,541786,749107,724136,310918,657816,242000,903305,339841,313383,653212,888679,466651,683829,1016080,584557,77664,963073,1021088,574265,544900,192850,379556,20660,711891,287681,574504,570444,255968,929894,695941,665722,99464,110148,730996,727584,798638,45017,1042764,64437,289347,713148,957174,286284,143099,1004861,834369,729491,777272,388219,247993,344738,226681,473679,356647,589689,367086,641499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002089s ]