SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304049 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304049 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117378,922950,481453,446809,327822,507609,109864,413343,285824,473838,81547,314033,729262,388647,1025108,118707,671060,170850,609027,783187,677561,262272,713379,569265,427653,170298,857394,945317,236045,658293,367701,438728,560392,720190,410909,243423,582729,90076,664071,559473,861430,347280,784554,176434,485747,565991,562003,1018340,419849,290192,316564,67761,842310,42000,436353,296881,778107,335282,653771,81247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]