SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 207106 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 207106 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124891,14316,803201,1015094,152009,176370,790817,54973,504814,936782,980318,857333,533034,197738,333211,382097,318079,110487,192717,871621,559684,997637,12977,924930,150341,325923,279972,844772,322029,920453,696175,635813,500501,684093,267935,453522,581739,286696,876507,328455,96056,726573,847857,375728,526005,872910,450392,197905,973188,461022,1003032,822416,602281,251903,923946,588617,468756,446651,375591,537454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 207106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 207106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003770s ]