SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41060 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41060 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614051,265336,808733,19149,892491,272311,698281,986942,549320,315120,873006,655131,851850,609104,242291,445316,215142,848583,242003,526585,12086,665815,566978,2110,695192,988046,110520,687169,895221,847901,341788,247480,628747,298715,113919,461585,529773,1032353,898475,477659,909966,965733,471569,754322,284566,263446,965670,537402,816132,538794,481052,394174,704450,119311,99195,794228,528920,81624,782228,675924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]