SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515094 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515094 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313468,477547,454103,629527,68552,912148,747426,994527,1017170,960947,446831,220838,227356,783277,128171,182925,654175,416615,966695,765531,60369,551821,145658,9888,299985,684725,373877,107288,438239,882166,768758,866158,1000684,454976,608805,207121,160542,842484,360992,172114,226796,346248,727156,252523,933845,591637,543833,205420,343078,153570,488570,772891,696174,521368,638437,476563,264553,572258,453894,128813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003179s ]