SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535498 LIMIT 1 [ RunTime:0.001797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535498 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609328,499009,789694,1011485,220908,714274,78921,555310,342986,640082,583093,41268,952566,391100,609710,470823,832429,514841,247587,166134,364588,241595,805066,626250,1005068,231256,29085,301033,537836,287223,741567,991937,441533,995132,87872,932632,291204,763334,563474,840769,265254,593047,395877,158147,616789,772142,617709,615601,84367,599512,618001,591013,1031294,422209,699539,822152,1015826,253325,166857,570745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002031s ]