SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509697 LIMIT 1 [ RunTime:0.006857s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509697 [ RunTime:0.004893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443383,721335,524247,48778,788317,658850,884663,493676,114668,560375,111366,595485,266079,998846,511965,495152,513939,663324,504014,173614,54262,50111,102023,225781,441773,777901,44501,296849,751769,750477,104208,368865,123038,510537,31414,772652,774551,131774,366578,207227,109620,83013,340443,995088,168350,483536,318600,23850,485147,7440,633572,390562,514897,360276,741333,369862,883014,468491,46563,131820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]