SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328804 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328804 [ RunTime:0.004784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691210,888320,616311,420005,955382,588176,356748,241164,938748,786323,853295,264149,656832,887607,105365,752531,551791,967263,225215,549598,815960,434348,516524,64611,175104,405991,677725,256709,535735,606736,222168,991831,292717,403499,719517,881795,778120,878088,1022876,5099,295481,186024,799145,478897,444406,335828,807471,199362,1014275,784448,897125,439840,1005956,19432,231834,844954,891705,857585,843862,772892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002054s ]