SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44604 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44604 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002307,324719,468788,479717,102575,110511,534608,760416,570900,346093,388328,94568,219786,114410,444481,346725,825433,422766,499671,309488,442425,321419,325016,1016325,608321,894883,720750,560356,203536,795005,905054,996044,1030282,603238,128566,256285,484044,84354,648102,904345,968712,842391,1014510,627394,853516,469727,261113,327580,665619,153237,262730,555189,297054,92649,736502,687076,972134,498461,843070,490679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]