SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68104 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68104 [ RunTime:0.003081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650378,447437,713936,113115,758216,552807,944605,706524,459784,279088,129493,417487,969556,516929,597242,1026075,46335,167511,189601,1719,161930,267109,722496,1039218,614403,775450,867393,536603,40337,11886,573382,968783,915837,56649,14692,454944,251676,986055,37351,639903,240160,754952,427185,1666,371363,710791,12181,185929,990326,691573,751717,585229,763597,748019,639509,82580,590641,164176,158757,266600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]