SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4588 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4588 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352250,134352,238132,906938,179029,786106,692315,190881,452201,185210,955529,39096,304025,405055,666549,558964,1031523,773401,715290,171500,942118,428517,360386,386713,325025,710317,148479,158569,703011,147950,445430,413578,465153,564703,251083,802057,205528,716535,810546,217871,554008,184480,838429,240353,375953,966439,989386,192595,817782,400319,1038385,322697,921355,992129,86277,716151,665489,961232,708787,306857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]