SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504108 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504108 [ RunTime:0.003345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936695,349373,564684,153131,598493,69920,159869,865033,271771,1040908,823131,619833,803496,289913,695712,389832,39899,703232,474228,257759,91374,453100,884903,196507,728328,896667,929572,457724,220633,600687,425029,596101,677026,320581,75172,465735,5997,411696,771821,1043001,559668,980353,1005327,18167,939321,928293,1012108,579572,105833,458345,1003591,677134,485344,498859,727786,943286,504050,883117,1015138,1036271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]