SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569809 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569809 [ RunTime:0.004036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921328,10782,983925,725129,95669,1048758,846878,1003273,23111,671581,859986,94333,789979,524008,659652,809007,641463,510301,749926,370524,19463,889071,256097,725601,775213,851846,734253,852488,316483,150530,638376,512795,289915,346470,116614,134452,873459,163650,634735,456425,798927,865535,963135,373802,992945,89230,195822,98190,1012721,367574,59981,823212,976045,22328,161065,254131,463755,986496,1005038,305759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]