SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685218 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685218 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512732,311913,614350,1029164,305941,830439,653999,48290,542946,973230,832079,626545,635903,777774,193964,976426,940509,943687,229619,892552,269694,395346,219103,366874,351917,747900,49098,736562,370300,130204,162758,320016,155178,261144,436509,655534,1043374,150706,221971,914509,204193,401456,964511,787924,303612,919483,637213,404689,724416,81989,772167,906038,449346,288551,631484,452808,661068,415899,585368,386383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]