SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284809 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284809 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019167,959106,803015,69329,348103,320329,136685,507958,80496,413165,927916,621442,52075,879625,609456,272236,532554,220253,589996,553329,852516,1016386,68248,403055,417517,355781,859216,981765,377898,278298,545258,847307,620884,150668,238498,961610,675962,575594,971481,845840,224400,799606,1016521,225268,210737,728430,632185,948953,569671,503641,395947,443013,888295,30753,928916,855419,188726,711394,66971,884956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]