SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489521 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489521 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951971,502949,435744,188625,954572,853873,231159,1032502,357083,368658,357282,185778,185774,841505,295322,760710,992538,540647,570149,757907,897022,285292,149740,21123,246199,177730,1043681,453656,318375,606006,512089,170082,116413,276921,1021743,1005644,346912,322521,657370,37341,741045,307488,981460,375324,301642,227281,937552,820267,622032,354712,179921,388001,941117,984774,626131,884345,107438,232850,643641,768047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]