SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019045 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019045 [ RunTime:0.003134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941284,530392,259847,1031735,489343,317846,240084,701010,1024347,495461,282399,154045,110084,370447,988212,110690,51532,743855,963422,493730,810248,531762,221777,285449,350853,555445,81911,721275,212781,726514,596217,863296,457979,268662,303961,321412,139846,726876,34659,758075,207858,1030921,900329,458383,832768,401322,181785,218082,466744,714372,469276,340596,734274,759531,946320,74669,224510,693811,48256,44863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]