SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 258200 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 258200 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024886,259655,849888,1048598,496106,556863,347122,285591,822309,810474,343029,150997,58841,171205,959860,275173,78241,270140,753937,941976,994866,555240,61081,862296,13123,441081,315426,1048794,930059,613354,610482,243231,431160,583199,361005,710011,506991,649883,471545,457101,473196,376839,104119,363471,605688,59718,573396,453995,601836,950146,101018,16307,770792,631941,668678,987419,282893,698284,365081,130410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 258200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 258200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002484s ]