SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508099 LIMIT 1 [ RunTime:0.000619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508099 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143005,678230,632823,604889,286812,72990,71384,404840,80353,726529,937336,849860,543698,501171,1034252,666896,151703,901941,494227,606027,790995,572110,1041775,949766,999926,212446,346833,764243,396257,782779,884207,387517,340418,604879,773131,297722,392267,13941,1044278,551776,817027,1032121,91785,1045965,888319,954894,604823,700599,912477,517563,946977,724063,622505,642812,1000796,452037,678866,1041380,301508,456691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]