SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46203 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46203 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240683,754753,455987,763960,428179,403603,359340,378959,524421,1026370,53491,718104,98838,343782,735481,284795,146572,36574,790441,552062,208681,552563,110233,862645,760242,963027,506050,678400,480812,933238,1030742,187886,825219,1045720,1033659,572348,911587,251565,349446,419201,83390,1045935,495549,621304,824971,295565,49061,193435,349346,94387,57844,19465,1045857,113868,822325,236144,844262,476070,279753,336690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]