SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409613 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409613 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99819,119308,333823,493419,610077,181662,672643,84587,533409,592407,719588,611055,390368,788349,446362,341815,811318,307024,710335,108833,531564,287276,199340,792922,151990,431792,245234,294786,866826,436558,719524,480547,30304,660299,807637,872433,782465,405378,137371,740045,442922,426525,260476,242479,446104,822847,319388,7850,434124,280866,748385,676117,261920,760558,432095,993927,958275,866604,711065,156164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]