SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801360 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801360 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530516,140588,573248,425316,70152,47651,751970,1009194,591308,654497,229233,436664,716175,254230,80814,509105,264037,276823,448851,796382,167637,821554,491644,763082,910127,790776,953083,237646,785581,823689,246852,141481,320343,744478,227982,667177,196524,809876,650061,267631,908603,1025381,546610,701455,760789,895983,824006,765088,457347,717086,769986,237130,716792,493229,1017290,620760,388798,926786,430685,490818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]