SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004102 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004102 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677714,185549,640287,804127,1013510,445068,338550,219990,365075,376597,757962,784425,283675,801388,11725,149419,701539,299319,574625,604403,495593,692514,637092,2187,219585,71899,380346,723582,2730,564374,938777,59849,179998,639135,455356,150048,854825,107257,442038,212933,100273,311632,1041586,535033,141060,123942,956982,661998,860707,936828,326338,491370,543575,792555,517805,521313,120267,703458,74962,908021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]