SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000481 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000481 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721295,568741,1004410,478619,451922,783166,483115,1026421,717696,920230,425409,569397,164627,188900,130196,789585,178012,804805,274343,298819,677882,45338,543554,68330,420386,724440,283221,527638,630477,874248,755170,401142,590247,166049,335974,688544,664842,138147,158829,657879,8502,478648,869964,938866,1038242,522005,529213,17545,738889,225213,624866,757946,299961,274580,826413,234745,906400,807791,528526,80395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]