SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533102 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533102 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837005,250834,675490,437010,1008028,411296,422862,345918,991240,758103,831098,548899,657579,615794,6851,965239,183114,623583,64930,479293,967503,506790,113312,291348,506843,953164,580971,474675,974151,640836,84032,326076,182871,268244,523645,93979,96736,441595,506086,814956,88062,843221,442134,418730,877042,228545,407414,949975,120557,924074,185739,214436,801007,118928,141540,228994,513741,906156,36351,627769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]