SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407427 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407427 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853168,301854,49225,334822,323061,189476,18240,991106,801378,97011,456111,245129,656806,558174,981075,843740,610040,439543,792110,560286,607476,242837,681719,734362,247369,473244,679265,171075,973773,1041735,918507,47745,121942,796686,694289,907343,213885,760142,998983,558654,256139,220344,185642,658588,448480,409468,180189,252265,846070,692577,890787,260790,759585,906624,137243,160823,291427,581705,948391,624939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]