SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44543 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44543 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424571,121485,504098,67674,466435,425196,496480,255961,204216,569406,287712,113123,369396,48474,766900,1025586,330211,451264,883112,690369,543402,156256,753326,49082,633709,783950,765335,707270,746224,713200,1006817,846072,1020216,451872,563060,183212,184633,233986,353679,406890,436415,299852,872147,1025708,687068,591569,62297,6907,207127,42961,44376,137258,503117,232931,324351,761379,807860,711349,286530,814278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]