SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507993 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507993 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585852,936274,41331,1033810,334636,139998,896892,738268,602099,510541,7767,119369,707109,717848,807922,705952,404414,17803,1040999,416290,319881,522214,419923,788600,838591,33256,368513,729163,1044102,667814,713451,558697,289432,595678,78492,579406,45571,1027160,409581,396319,165200,627843,668291,523494,841947,422989,807527,338617,494041,732351,244757,162863,12118,142748,550105,1037441,669851,97362,680733,764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]