SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343781 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343781 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563528,621609,471158,556247,7018,628822,469999,1041383,423290,548691,242626,47412,647062,284630,555428,561378,233067,721676,588218,383993,621639,462892,457235,954831,644091,609390,11951,468165,983865,762930,74107,202553,819578,757902,546805,911647,487246,229781,652259,18357,595702,630463,980043,11598,429864,519030,214629,436372,548929,983833,664201,626664,65830,938427,590798,1037655,70802,830096,820660,590241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001093s ]