SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489715 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489715 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430987,977067,1018515,446633,459389,405552,536524,878653,83707,11573,293299,273982,918298,89902,804357,669731,317763,837000,564501,1026566,761552,566786,230660,361851,197258,685402,158715,41697,447813,270499,934042,723395,1035547,674726,885044,143767,666406,473913,1017756,537175,1043106,662339,94093,168712,61222,985315,896859,322694,650256,199346,859355,945062,262713,432094,879018,1046299,83063,160030,228918,1031695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]