SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455345 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455345 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588682,1022189,963214,690328,128178,106127,309027,456460,563872,732738,842138,574456,523650,584176,513002,978664,576846,660393,208632,311482,259709,783282,857775,101034,973618,214352,146125,518998,754806,303994,703411,995760,141071,442908,33153,958088,191082,425699,315259,2793,178418,817955,191689,479970,409037,938265,41486,509073,70923,330388,301493,382237,815051,619904,344924,856972,986107,810873,265038,687974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455345 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455345 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]