SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005893 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005893 [ RunTime:0.002306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020380,418937,642637,330427,142419,290708,415707,416043,472720,791022,442448,808125,156270,20342,1027873,37239,954008,208292,197080,48779,721477,354265,1014339,277638,887605,127797,1023514,339428,990876,833442,910570,990896,288498,698266,522947,35551,881734,783894,118728,1010334,524414,7256,944328,1034603,685856,621826,819643,1007192,511366,536280,978739,942802,611217,974261,284592,360675,1012345,878888,775628,228380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]