SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434581 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434581 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476533,470939,166219,207849,370767,384219,865614,241572,483878,753652,893188,765171,246876,189612,932990,1022919,680323,1005002,472082,444397,388966,402145,133965,9711,172402,250815,585643,512935,89779,68935,589405,383638,955905,618894,19567,73193,165631,175468,314988,890438,359039,677580,764176,394435,632480,117998,870848,219607,946551,777758,55473,415518,630371,782947,709618,44774,114116,904219,256244,228204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]