SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413841 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413841 [ RunTime:0.006689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20957,549124,165634,125778,208821,645895,970583,35538,661441,277163,742684,876490,375288,311130,1001372,659129,775334,193281,334644,724045,707211,669678,172373,429178,222762,379442,16797,581796,128663,506297,812039,341735,609637,502295,406351,1022993,534137,572341,715766,893863,716524,535053,842524,490314,814884,983537,170988,912988,1018779,112677,1008397,176678,612791,317422,468029,804626,1021507,504591,572770,437049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]