SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326320 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326320 [ RunTime:0.002678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809267,734887,78744,815328,56664,455584,343887,667368,663965,614112,431777,59819,767849,705579,7903,961003,922703,465139,213873,1045306,153020,361530,469039,649807,97274,902921,871918,331440,762775,890067,101512,233183,375079,17349,866126,140751,878887,3861,796468,373966,892399,1033920,289927,164518,234227,531302,89518,332762,65882,493230,900745,674640,879192,3472,1006810,161851,679559,989933,703814,148425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]