SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 919400 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 919400 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210413,122642,814146,948803,80704,391081,962537,63898,849448,422779,916609,423041,933916,610089,987234,105265,66990,660041,639077,820326,357765,267190,433112,612663,735587,47324,420194,473573,521790,472152,4112,992756,597182,217090,878856,840127,739289,699435,1010760,496883,128420,330206,684762,520780,416511,920916,265894,503776,465612,702200,954876,8559,61798,718258,243788,408546,519884,149888,607286,485635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 919400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 919400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]