SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041031 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041031 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712337,257478,138548,477782,266827,591368,709903,1000248,225255,419773,325396,667777,499967,731231,736366,132735,339491,998003,21523,522911,1047346,764785,78327,780194,382743,298593,840805,966057,647328,957151,466089,824914,110453,269970,655485,1034570,878801,52952,690238,680475,461363,47787,516394,294585,205683,889242,796577,248321,230321,37046,658169,549402,977780,953842,733173,201992,907770,37643,678702,719453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]