SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010675 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010675 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460920,987003,1024190,40010,85860,1014703,546809,215828,662612,929305,302689,849751,111441,697115,916607,1041001,698967,1044070,643040,93552,716309,794964,158375,179363,425401,179404,281928,80142,853063,344608,137673,419624,360879,28820,798003,204863,911712,40286,911373,300854,389367,245541,182319,917764,25681,481044,525772,807770,574074,714627,283372,387652,808154,341557,409832,1014606,144554,550444,175541,534757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]