SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486840 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486840 [ RunTime:0.003661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236613,1003435,308361,252788,735181,1013099,128733,40595,444505,175560,527123,718612,483403,571410,220907,226326,754120,503633,831717,521204,254721,849932,82024,353777,260519,510757,850385,830734,554910,513438,661687,350428,80916,799869,849847,587512,429751,737800,306945,814434,161620,969606,131924,935845,228159,937095,522141,581803,969168,985770,24795,259677,292914,462939,975625,256332,130722,42003,739776,350884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]