SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710516 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710516 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654633,31879,689068,527577,114626,802087,906194,105230,402374,385600,101620,315922,916036,2270,232152,834263,195054,631173,934206,137714,236719,452573,79877,962017,521233,534243,538688,157731,477901,986482,355867,720074,955609,566607,372638,595580,823556,275207,244858,81926,812049,679582,339200,466831,589323,437454,188639,681082,148933,885845,984923,106640,605663,555914,111686,254295,142363,8199,111056,250948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]