SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029121 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029121 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269400,305815,357173,667332,357635,104584,736599,1039973,534421,928129,743843,432218,313116,601269,851931,599754,747774,787496,256571,577458,256824,297166,298315,633745,313196,258859,68990,126580,86990,770787,133626,27747,1007790,660301,697723,457812,1046188,1013667,38817,971918,316767,747677,357874,140913,545289,558672,974367,702471,904225,401208,874889,750882,525466,460505,493617,159727,792500,922416,890405,459262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]