SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45312 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45312 [ RunTime:0.005446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000487,679588,961025,224820,495374,258140,209480,813357,494655,198719,535374,384167,544498,866239,952491,793748,441080,595477,881176,855918,450434,819680,128597,396424,506808,965645,192849,395021,422400,396487,625002,172999,1031581,360330,867669,108853,677884,502040,640020,705165,619243,398927,972881,598810,127798,359436,972742,203367,978151,658071,298265,486242,724868,735755,344450,303642,390643,968152,374393,631830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]