SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045812 LIMIT 1 [ RunTime:0.005926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045812 [ RunTime:0.004955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047427,749638,225251,51013,332217,198758,694145,759478,441924,409013,598622,735699,785654,44926,140322,222273,616392,486667,153561,333275,142126,41677,635220,685076,926846,422815,504438,304174,946789,783276,1040479,1009374,374575,710560,307628,961642,310072,605738,848479,312314,140435,141298,413970,175012,45533,1006672,145018,14699,840320,119767,595914,186847,851503,235269,471608,523427,924211,291754,451982,35470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]