SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546610 LIMIT 1 [ RunTime:0.000927s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546610 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645400,113273,488178,1045569,1015966,437259,704495,241105,194490,426355,172067,325496,603525,516649,613910,633867,687633,528480,322673,1023106,943486,433330,700022,32767,204409,782190,717989,405917,1046809,765024,45814,73949,822731,617541,921639,939868,396807,258043,19751,193460,687349,115594,636385,434217,692675,934519,310030,906726,21592,329062,941319,145642,372147,129769,863418,398044,189714,737034,336448,31385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]