SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46708 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46708 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428399,346213,766167,245923,519054,564440,952264,229872,538736,355988,950424,380945,1043876,173931,844505,281437,274976,34029,997606,605475,174834,477438,196205,1007102,633383,104412,402645,859925,84052,95192,1048782,208424,818067,567873,831465,697309,234136,217731,637134,298366,118963,774858,698143,478406,1009851,981396,951330,37737,437951,537846,184100,237984,1006356,208296,148085,783819,787082,33001,737826,831895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002024s ]