SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392442 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392442 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024668,187122,335151,3489,899848,20694,937259,481205,1034705,464990,599184,271533,289198,996394,166471,470587,615379,947081,590521,851966,975918,685147,863250,305565,709860,608734,293881,849158,606042,122102,417995,871616,498842,361059,252407,823390,164847,458017,679683,948623,19490,431462,37202,740165,308606,1025080,788124,835215,595013,40605,96184,143473,783090,988234,1038113,468797,769347,580200,77991,888460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]