SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681012 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681012 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126157,953879,145077,923956,724515,43297,616526,168288,540316,230786,296386,886844,328738,311421,977404,415254,81742,970241,322880,150985,1041556,904630,581821,95319,413461,864068,1038715,383133,840446,543439,129905,956315,87595,400194,165448,553874,135130,2552,265553,385522,466480,817552,951944,492834,815277,1029739,139672,55177,1022849,552501,82167,326807,512305,1508,458776,145342,773279,85184,1010252,833060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]