SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562816 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562816 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865647,886569,421914,34316,280851,104947,817653,938582,276102,432405,3850,9057,844551,876159,547701,841663,1027533,332178,226723,906443,634880,584090,525447,949784,550434,257704,284223,496031,18279,469318,1025735,511843,358098,708642,1019251,881599,43062,429625,970568,91312,229635,221917,537402,710957,205199,676815,323330,222000,140950,487521,791443,641216,421103,532341,577769,772391,670800,737616,898783,693454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]