SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915682 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915682 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839085,602002,551139,498952,424889,356175,745586,868473,651442,1038080,691537,346573,508724,860668,1045580,877436,104629,118910,859948,38588,456290,716994,98375,57954,621828,393080,433086,974888,161792,27700,686498,448405,917528,164407,234778,606373,273382,421312,908620,370421,1025219,372710,163140,159546,581920,241866,313100,535826,505202,500795,85550,83064,246544,883015,837237,144921,691720,923058,276261,98251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]