SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316838 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316838 [ RunTime:0.010088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677238,503662,233143,859567,612510,1011277,718786,211439,722253,100062,905753,402015,536590,372961,363017,135602,403651,937362,133053,750042,416403,799426,183881,665192,41070,807646,358158,314220,695862,706871,562746,598200,785121,144853,601803,569639,613189,268152,967501,1001066,557961,600516,360273,698645,123858,465435,442550,50569,909136,779437,616317,601180,263965,421972,236018,331626,397297,782368,423730,203554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]