SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401226 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401226 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922510,891742,191263,168047,407749,108082,214408,22287,860424,520536,770164,166625,345507,248746,887786,627718,356681,981951,203677,553189,388945,383907,403383,39684,174086,43561,466712,567165,390589,648637,120499,416130,706991,387260,766879,1043328,566019,789949,178051,854947,804051,288870,493867,597341,63383,872398,893709,192419,869393,879470,122454,545798,864263,394246,456669,414021,426523,872673,50225,508107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]