SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012682 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012682 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426198,278139,280796,646934,64137,826743,120287,630383,835707,806526,794371,781960,762492,760064,951328,776435,82049,729543,621520,80394,826330,1016477,518886,1032767,267173,276261,121448,928077,1031980,1044314,457152,969405,674759,720270,1008434,508898,231296,306592,329273,514947,441644,281528,369532,723330,596801,923813,363290,328307,1021269,903885,327697,85780,912841,213028,146422,879766,813718,25333,426957,94767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]