SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452509 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452509 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924590,111881,197548,1024753,851821,994874,96360,78950,58047,854486,47841,9963,633531,994051,976976,817791,248535,713807,511916,72432,806131,215650,817742,537844,523480,707101,150297,234951,385762,297508,847935,42304,712236,259299,548757,257604,582580,218107,375064,505205,810457,341488,485166,141796,133456,227932,498161,179137,553690,605868,234660,1020486,593782,881897,666995,898235,28484,404143,90844,950232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]