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` = 462014 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462014 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36220,741447,176325,567136,730842,204945,697082,855621,657208,989770,191805,884892,485748,575029,828141,977157,916136,940081,275976,624195,932044,120585,961788,465191,597937,852006,946508,588333,1048131,301916,270626,54729,845066,583898,374995,405014,294425,887110,117634,650618,376775,92572,424027,431590,710752,155629,570146,5641,265323,692985,219884,869164,189388,548789,340945,505166,612370,957072,433004,183568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]