SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840358 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840358 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023914,259178,516355,343364,585460,111769,446883,102016,328603,372905,919125,892213,762030,486129,417958,141893,967131,927881,1029770,1012763,722598,504730,163349,213373,754914,1047060,936092,928121,267668,954475,994135,195850,695990,909025,870232,321052,692782,430655,36812,942493,798548,678678,22006,55797,806400,806696,373606,162777,141703,659388,968206,682270,170459,518310,795170,479646,747010,663328,708010,787435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]