SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 909428 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 909428 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200478,901120,973192,1014345,93861,753725,9290,573849,15025,181669,889912,795692,852925,713038,123494,143737,454305,322623,768275,992592,116497,459648,155488,671555,223470,656472,180014,508834,550674,227031,104980,595694,420902,476439,250538,538057,2663,934562,840561,547883,887193,704746,598179,49391,891747,385581,634247,356483,843902,780,829751,653752,579062,572779,182303,367281,396355,6966,200098,811833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 909428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 909428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]