SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484080 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484080 [ RunTime:0.003509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439071,642230,133022,539436,912948,816022,355559,946216,940052,851015,587508,394404,536177,443812,925858,287875,178209,829734,93327,360918,303772,697257,573873,369392,123867,224261,1030602,205190,690987,65998,833998,355089,741276,527795,1042770,224574,91145,722997,218114,867031,762293,1045651,137468,304780,806099,186511,687795,994712,166069,471219,637070,635062,274544,622230,499492,598825,971732,322912,696873,784959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]