SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492520 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492520 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513717,460095,597920,196460,829496,467488,525379,777889,530090,529087,928828,474383,627533,594705,221699,233060,271582,495851,202841,617526,876772,1035221,1002012,408575,904109,245243,726346,612148,239093,358552,912976,562023,517725,547355,948969,40686,40313,921931,255798,684357,611293,316271,281862,46857,235020,388163,452451,847931,821875,180273,154116,959272,201101,229279,447648,791379,498610,659936,356728,345281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]