SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494393 LIMIT 1 [ RunTime:0.000628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494393 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533494,1002873,225246,947149,822133,279354,179359,301024,1030676,201813,410134,135639,834858,789522,119132,140278,384938,605841,571516,844859,929977,286018,979533,1002303,508257,990985,328917,100531,144740,930089,433931,319085,677076,712254,469051,281484,1020673,156147,136,855302,676184,880561,1008155,402135,651297,356257,135351,746327,663797,983815,565831,479110,487048,925947,369892,540270,105435,571020,1022229,238260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001648s ]