SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985251 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985251 [ RunTime:0.005263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171407,252252,947986,598421,997660,177081,1043121,194533,699753,835081,1033353,151075,790544,138661,441955,513429,567544,678171,601785,632631,300470,228709,475426,483072,334812,748663,217391,930973,749244,946367,997499,907873,555736,698115,72492,460497,561533,434477,771904,805623,295395,677896,923947,287910,375449,618645,196911,148129,141320,892794,173509,210489,139857,76289,745393,648488,214360,439997,438493,662405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]