SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043548 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043548 [ RunTime:0.013623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100633,797578,829634,867972,674724,50823,86230,953825,376287,726578,988114,850247,830056,134817,991309,654923,454730,207810,360939,544655,1013133,329297,693537,300915,192487,700032,631234,336217,825824,945974,557339,360311,164433,704789,75434,60861,253811,920820,624973,110257,632663,704332,314195,943572,414267,595377,476311,558061,830072,916968,405898,353249,184674,94225,955421,609642,203079,1020856,433894,524861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001747s ]