SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432142 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432142 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516030,929148,815272,25966,847549,964490,435233,206040,361304,925722,1046692,802733,886114,175883,654679,586844,129967,590043,378056,142071,462595,350083,946617,310083,717667,353805,182524,650877,380240,730605,131892,980328,433388,573615,313526,416817,547508,272673,992461,929523,845225,346605,176354,957256,783140,282618,883509,203704,837524,99584,471926,1048786,507334,543783,496987,393772,460828,7929,390091,323959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]