SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306560 LIMIT 1 [ RunTime:0.002060s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306560 [ RunTime:0.005217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521709,431617,481487,913603,239798,609712,19747,466031,421922,470228,328500,484232,976727,4448,1004952,572526,706187,45217,666725,760132,667592,541244,1001592,361606,495536,221934,671256,137820,1001902,635665,1020893,528170,718280,42269,651261,192939,503258,821253,427673,777280,968455,603575,179467,861699,403982,362739,770634,513534,928069,643518,965134,130664,159142,14206,8753,516425,262037,108795,131162,734018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]