SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036606 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036606 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771809,434320,375787,496993,482102,522017,169289,523982,641720,474863,834104,82912,603590,1048223,101288,968539,935495,333447,184465,886072,110902,164014,331643,454188,549308,859713,791545,797783,241062,588016,548423,773884,929458,430009,499359,807801,901234,52976,287445,734865,538709,935681,934710,366873,150509,910617,139278,270209,349975,243374,749731,685801,598266,998999,342579,190777,303973,918708,688224,317314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]