SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001221 LIMIT 1 [ RunTime:0.000992s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001221 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640121,364914,699818,509761,1047297,500354,1019541,921910,111775,351196,640608,23166,577922,352780,720187,256647,149865,826122,895977,120249,956954,510376,378204,921050,193901,31872,198457,10151,203470,27486,889709,968090,927363,739563,285693,557770,860440,123287,468561,323925,718879,893059,518114,482248,707724,370362,714929,295442,697400,398405,403697,738365,113858,772243,672932,465681,513361,542861,864445,159576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001096s ]