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` = 533775 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533775 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30269,841555,609927,849201,184504,860808,1029007,286228,916669,111331,1043859,843924,402886,286804,978045,817309,809583,278571,1023003,321014,90338,213137,446066,1014534,43376,683670,115963,293648,154335,473633,487665,253759,873338,558528,230168,993977,12144,483045,840948,146184,559862,402835,897440,865814,410643,890173,251667,511985,58687,390669,89875,391987,366011,628432,913274,499556,1010392,548724,767447,423317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]