SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511692 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511692 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516034,769822,108769,69882,1007478,411218,1006889,910516,980087,529679,923781,823638,261146,565642,7416,416217,453986,355766,58725,483395,179689,504932,836244,10931,526365,158567,759560,261254,778549,561770,526488,527684,303720,723877,961064,365073,555314,94066,1045496,366123,63805,29381,555956,793031,161786,247235,26335,361308,21227,362938,789265,436962,895042,937644,477748,630195,643840,995419,182803,573451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]