SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310568 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310568 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679016,846180,14946,1047319,636821,100261,931527,359198,9576,530992,186814,403357,625779,378242,1011010,161969,64611,852665,290356,727779,93475,647436,564039,146195,174359,546454,541801,404578,672454,648734,801299,844675,292491,659072,474243,656150,549713,2233,271940,599625,747335,740499,901763,717248,112849,678536,92328,1038117,346906,184805,27563,914224,47179,238827,342298,155874,896059,479765,634729,46978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]